package dao;

import entity.Dormitory;
import entity.Dormrooms;

import java.sql.SQLException;
import java.util.List;

public interface DormroomsDao {
    //根据id查询
     List <Dormrooms>cx2(Integer lid ) throws SQLException, ClassNotFoundException;
    //查询
    List<Dormrooms> cxb(Integer lid, int page, int pageSize ) throws SQLException, ClassNotFoundException;
    // 添加获取总记录数方法
    int getTotalCount(Integer lid) throws SQLException, ClassNotFoundException;
    //删除
    int scb(int id) throws SQLException, ClassNotFoundException;
    //修改
    int xgb(int room_id,int building_id,String room_number, int floor,int capacity) throws SQLException, ClassNotFoundException;

    //新增

    int tjb(int building_id,String room_number, int floor,int capacity) throws SQLException, ClassNotFoundException;

}
